Q1) Consider the following relational schema for a Company: Employee (Fname, Lname, Emp_id, Bdate, Address, Gender, Salary,Super_Emp_id, D_no) Department (D_name, D_no, D_Mgr_id, Mgr_start_date ) Dept_Location(D_no, D_location ) Project...

profilejowafhrulharbi
Home>Homework Answsers>Mathematics homework help>Algebra homework help

Q1) Consider the following relational schema for a Company:

Employee (Fname, Lname, Emp_id, Bdate, Address, Gender, Salary,Super_Emp_id, D_no)

Department (D_name, D_no, D_Mgr_id, Mgr_start_date )

Dept_Location(D_no, D_location )

Project (P_name, P_number, P_location, D_no )

Works_on (Emp_id, P_no, Hours )Write the following queries in relational algebra.

 

a. Find the total number of female employee in the Organization, whose salary is more than 25000
b. Find the names of the employee who do not have supervisors.
c. Find the names of employees who work on all projects controlled by department No 05
d. Make a list of project numbers for projects that involve an employee whose last name is “Smith”, either as a worker or as a manager of the department that controls the project.
e. Find the total number of Employees in organization.
f. Find the names of the employees who worked more than 10 hours on project “mobile”
    • 10 years ago
    • 5
    Report issue
    Answer(1)
    profile
    kittenj
    4.7 (103)
     (Not rated)
    Chat

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      relational_algebra.docx
    Bids(0)